SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=3 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+online +jobs +list' IN BOOLEAN MODE)) AND iCityID IN (15644,16399,16361,15626,15791,16347,15846,15689,15750,15804,15614,15719,15796,15739,15570,15684,16389,15620,14792,15751,15629,15754,15679,15732,15580,15867,16390,15555,15875,15788,15877,16541,15648,15560,15566,16133,15731,15546,15604,16391,15770,15806,15803,15887,15853,15646,15631,15549,15737,15790,15652,15694,15816,15820,15575,16419,15651,15831,15755,15757,15586,16548,15639,15568,15720,15835,15795,16384,15785,15693,15836,15717,15544,15858,16388,15578,15610,16546,15585,15879,15881,15665,15781,15726,15687,15569,15624,15819,15830,15772,15698,15654,15581,15784,15563,15625,15733,15637,15811,15865,15778,16547,15880,15851,15571,15574,15553,15771,15768,15746,15800,15716,16536,15749,16537,15641,16539,15701,15756,15844,15799,15659,15660,15884,15545,15603,15713,16364,16543,15683,15834,15632,15821,16357,16542,15591,15722,15669,15599,15825,15691,15812,15734,16140,15692,15729,16412,15740,15634,16602,15780,16545,16369,15681,16604,16544,16540,15559,15547,15883,16339,15815,15709,15828,15623,15805,15707,15656,15747,15839,15667,16538,15642,15715,15676,15868,15700,15758,16438,16606,15630,15888,15777,15848,15723,15706,15697,15661,15702,15847,15675,15763,15787,15813,15849,15810,15814,16415) ORDER BY FIELD(iCityID, 15644,16399,16361,15626,15791,16347,15846,15689,15750,15804,15614,15719,15796,15739,15570,15684,16389,15620,14792,15751,15629,15754,15679,15732,15580,15867,16390,15555,15875,15788,15877,16541,15648,15560,15566,16133,15731,15546,15604,16391,15770,15806,15803,15887,15853,15646,15631,15549,15737,15790,15652,15694,15816,15820,15575,16419,15651,15831,15755,15757,15586,16548,15639,15568,15720,15835,15795,16384,15785,15693,15836,15717,15544,15858,16388,15578,15610,16546,15585,15879,15881,15665,15781,15726,15687,15569,15624,15819,15830,15772,15698,15654,15581,15784,15563,15625,15733,15637,15811,15865,15778,16547,15880,15851,15571,15574,15553,15771,15768,15746,15800,15716,16536,15749,16537,15641,16539,15701,15756,15844,15799,15659,15660,15884,15545,15603,15713,16364,16543,15683,15834,15632,15821,16357,16542,15591,15722,15669,15599,15825,15691,15812,15734,16140,15692,15729,16412,15740,15634,16602,15780,16545,16369,15681,16604,16544,16540,15559,15547,15883,16339,15815,15709,15828,15623,15805,15707,15656,15747,15839,15667,16538,15642,15715,15676,15868,15700,15758,16438,16606,15630,15888,15777,15848,15723,15706,15697,15661,15702,15847,15675,15763,15787,15813,15849,15810,15814,16415) ASC, p.tmPosted DESC LIMIT 24
online jobs list, Job Classifieds, IT Jobs, Sales Jobs, Employers, Freelancers, Work from Home in Fairwood